---
title: DB-CLL-052 — Stamp the file-create date on a legal case
summary: Stamp the file-create date on a legal case
status: draft
owner: SAIF Case Management team
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# DB-CLL-052 — Stamp the file-create date on a legal case

## Classification

| Field | Value |
|---|---|
| SQL ID | DB-CLL-052 |
| Operation type | Misc |
| Execution method | StoredProc |
| Database | Oracle (Case Management) |
| Schema | [unqualified]** |
| Command type | Stored procedure call |
| Business object | clsCreateFile.UpdateCreateFile |
| Criteria property | n/a (custom method) |
| Lifecycle method | n/a |

## Parameters

| Name | Direction | Type | Default | Description |
|---|---|---|---|---|
| LegalCaseID | Input | NUMBER | N/A | Legal case identifier |
| FileCreateDate | Input | DATE | N/A | Date the physical/electronic file was created |

## Tables

| Table | Access | Columns/Notes |
|---|---|---|
| [LEGAL_CASE](../database-tables.md#legal_case) | UPDATE | LegalCaseID, FileCreateDate |

## Sample SQL

```sql
EXEC Pk80001_Legalnet.setFileCreateDate(:LegalCaseID, :FileCreateDate);
```

## Operations and processes

- [Create legal case file and assign document sequence](../operations/create-file-and-doc-sequence.md)

## Sources

- `SAIF.Business.Claim.Legal\LegalNet\clsCreateFile.vb`